You are here: Getting Started > Using 3sysACADEMIC > About Grids

About Grids

Grids appear throughout 3sysACADEMIC. In simple terms, they are tables used to present, add or extract information through the system.

Note: In 3sysACADEMIC Online Help, click Example image of a drop text icon, Example image of a drop text icon, More Details... or on images to expand them and see more detail. For more information, see 3sysACADEMIC Online Help Tips and Tricks.

About Grids for Presenting Data

The aim of these grids is to present data in an orderly fashion that makes its interpretation and navigation more straight forward for users. Examples of these grids include the Recent Activity grids on the module dashboards and data presented on Search screens.

Pastoral Management dashboard with Recent Activity highlighted

Pupils screen with grid of pupil details highlighted

For details on how to:

  • Use dashboards, see About Dashboards.
  • Use search screens, see the maintaining records sections within each module's Online Help pages.

Note: You can re-order a grid by single-clicking on fields in the header row. If Black arrow pointing up. is displayed, the list is ordered from lowest to highest. If Black arrow pointing down. appears, the list is ordered from highest to lowest.

About Grid Row Colour Coding

In newer modules, when editing data in a grid, coloured dots show you each row's status.

  Colour Indicates
White dot White No changes have been made.
Purple dot Purple That this is the row to which you are currently adding data.
A blue dot

Blue

That this is a newly created row and you have not saved it.
A yellow dot Yellow That you have amended this row, but not saved the changes.
A red dot Red That this row will be deleted when you save changes. The row contents are also crossed through with a red line.

Note: This functionality is available in the following module: Pastoral Management. (In the future it will be available for all relevant modules.)

About Grids for Extracting Data

When you see MS Excel icon above a grid, it means that its contents can be exported and saved as an MS Excel file.

ClosedHOW TO EXTRACT GRID DATA AS AN MS EXCEL FILE

  1. Click MS Excel icon.

    A popup appears asking what you would like to do with the file.

  2. Do ONE of the following:

    • Click Open to open the spreadsheet.
    • Click Save to save the file to your computer and Open to see it once it has been downloaded.
    • Click Arrow pointing down and Save as to save the spreadsheet in your preferred location.
    • Click Arrow pointing down and Save and open to save and automatically open the file.
    • Click Cancel or A diagonal cross which closes the window to abort the export.